﻿using MySqlConnector;

namespace Front._1127;

public partial class Login : Form
{
    public Login()
    {
        InitializeComponent();
    }

    private void button1_Click(object sender, EventArgs e) 
    {
        using var connection = new MySqlConnection("server=localhost;port=3306;database=book;user=root;password=Wu.20060322;charset=utf8mb4;AllowPublicKeyRetrieval=True;");
        connection.Open();

        string sql = "SELECT * FROM admin_info where admin_account=@account and admin_password=@pwd;";
        
        using var command = new MySqlCommand(sql, connection);
        
        //获取账号密码
        string account = this.textBox1.Text;
        string password =  this.textBox2.Text;
        //MD5加密
        string pwd=MD5Helper.GetMD5(password);
        //sql传参
        command.Parameters.AddWithValue("account", account);
        command.Parameters.AddWithValue("pwd", pwd);
        
        using var reader = command.ExecuteReader();

        if (reader.HasRows)
        {
            //登陆成功，跳转主窗体
            MainForm mainForm = new MainForm();
            mainForm.Show();
            this.Hide();
        }
        else
        {
            //登录失败
            MessageBox.Show(text:"账号或密码错误");
            //清空输入框
            this.textBox1.Text = "";
            this.textBox2.Text = "";
        }
    }
}